NEW
Font size
WorksheetsExcel Post-Assessment 1
Total questions: 10
Worksheet time: 5mins
What is the name for the rectangular box in an Excel worksheet where you enter data?
Field
Cell
Box
Container
In Excel, columns are labelled with letters (A, B, C...). How are rows labelled?
Roman Numerals (I, II, III...)
Numbers (1, 2, 3...)
Letters (AA, AB, AC...)
Symbols (#, $, %...)
Which of the following is the correct way to write a cell address?
Column Number + Row Letter (e.g., 1A)
Row Letter + Column Number (e.g., A1)
Column Letter + Row Number (e.g., A1)
Row Number + Column Letter (e.g., 1A)
Which formula would you use to add up the numbers in cells A1 through A5?
=SUM(A1-A5)
=ADD(A1:A5)
=TOTAL(A1 to A5)
=SUM(A1:A5)
What is the first character you must type to begin a formula in an Excel cell?
Plus sign (+)
Equal sign (=)
At symbol (@)
Dollar sign ($)
You want to make a cell's text bold, change its font colour, and add a background fill. Which Excel feature contains these tools?
Formulas Tab
Home Tab
Data Tab
Review Tab
If you see ####### in a cell, what does it most likely mean?
The formula contains an error.
The cell is locked.
The column is too narrow to display the content.
The text is formatted as hidden.
Which keyboard shortcut is commonly used to save your Excel workbook?
Ctrl + C
Ctrl + V
Ctrl + S
Ctrl + P
What does the 'Fill Handle' (the small square at the bottom-right corner of a selected cell) allow you to do?
Delete the cell's contents
Resize the column width
Copy the cell's contents or fill a series (like days or numbers) into adjacent cells
Merge multiple cells
You have a list of products in Column A and their prices in Column B. You want to quickly see the highest price. What is the simplest function to use?
=MIN(B:B)
=MAX(B:B)
=AVERAGE(B:B)
=COUNT(B:B)
