What is Microsoft Excel primarily used for?, Word processing, Data storage and analysis, Video editing, Graphic design, What is the intersection of a row and a column called?, Sheet, Box, Cell, Table, Which symbol is used to start a formula in Excel?, #, =, @, %, What does the SUM function do?, Multiplies numbers, Adds numbers, Subtracts numbers, Divides numbers, What is the default file extension of Excel workbooks?, .docx, .pptx, .xlsx, .txt, Which function is used to find the minimum of values?, SUM, COUNT, AVERAGE, MIN, What is a workbook in Excel?, A single worksheet, B. A collection of worksheets, C. A chart, D. A database, What does the COUNT function do?, Counts all cells, Counts cells with text, Counts cells with numbers, Counts blank cells, What is used to create charts in Excel?, Insert tab, Home tab, Data tab, Review tab, What does the IF function do?, Performs calculations, Checks a condition, Sorts data, Formats cells, Which of the following is NOT a valid Excel chart type?, Pie chart, B. Line chart, C. Histogram, D. Paragraph chart, What is a cell reference?, The value in a cell, The name of a worksheet, The address of a cell, The format of a cell, What does the Fill Handle do?, Deletes data, Colours cells, Copies or extends data, Inserts rows, What is sorting in Excel?, Arranging data in a specific order, Deleting duplicate data, Highlighting cells, Creating formulas, What does the AutoSum feature do?, Deletes numbers, Automatically applies SUM function, Formats cells, Sorts data, What is the purpose of “Recommended Charts”?, To delete old charts, To suggest suitable charts based on selected data, To format charts, To print charts, How can you move a chart to another sheet?, Drag it manually, Use “Move Chart” option, Copy and paste, Use Format Painter, What does the Filter feature do?, Deletes data, Organises worksheets, Displays only selected data based on criteria, Creates charts, What is the Freeze Panes feature used for?, Lock formulas, Keep rows or columns visible while scrolling, Lock the entire workbook, Prevent editing, What does the $ symbol represent in a formula?, Currency format, Absolute reference, Incorrect value, Text format, Which of the following is an example of an absolute cell reference?, A1, A$1, $A$1, A1:A10, What is a relative cell reference?, A fixed reference, A changing reference when copied, A locked reference, A text format, What are data labels in a chart?, Titles of worksheets, Values shown on chart elements, Background colours, Axis names only, How can you increase the width of a column?, Double-click the column header boundary, Press Enter, Use Delete, Insert chart, What does linking sheets mean in Excel?, Combining workbooks, Referencing data from another worksheet, Deleting sheets, Printing sheets, Why is clicking on a cell more useful than typing a value when copying formulas in Excel?, It makes the worksheet colourful, It allows formulas to adjust automatically when copied, It prevents formulas from working, It keeps the numbers fixed, Where is the Filter option typically found?, Insert tab, Data tab, Review tab, View tab, What happens if you copy a relative formula to another cell?, It becomes text, It stays the same, It adjusts automatically, It deletes itself, What is the purpose of the Format Painter tool in Excel?, To copy formulas between cells, To copy formatting from one cell and apply it to another, To create charts, To delete cell styles, Which function key is used to quickly create a chart from selected data on a new sheet?, F1, F5, F11, F12

Basic Excel

von
Drucken
Einbetten

Bestenliste

Visueller Stil

Einstellungen

Vorlage ändern

Soll die automatisch gespeicherte Aktivität wiederhergestellt werden?