NEW
Font size
WorksheetsS3 Admin Spreadsheet Topic Entry
Total questions: 15
Worksheet time: 8mins
What is the primary function of cells in Microsoft Excel?
To create charts only
To store individual pieces of data in a spreadsheet
To format text colors
To print documents
Which view allows you to see the actual formulas in cells rather than their calculated results?
Normal view
Page layout view
Formula view
Print preview
How are columns identified in Excel?
By numbers (1, 2, 3...)
By letters (A, B, C...)
By symbols (#, @, &...)
By colors
To format a number as currency, which button would you use in the Number group on the Home tab?
Pounds (£)
Percentage (%)
Decimal point (.)
Number format
Which chart type would be best to show the distribution of sales across different product categories?
Line graph
Scatter plot
Pie chart
XY chart
What is the purpose of gridlines in Excel?
They are purely decorative
They help separate and visually organize data in cells
They only appear when printing
They are used for drawing pictures
In a bar chart, what does the y-axis typically represent?
Categories
Values or measurements
How can you make row and column headings visible when scrolling through a large spreadsheet?
Use the zoom function
Freeze panes
Hide columns
Split screen
Which chart type is best suited for showing trends over time?
Pie chart
Bar chart
Line graph
Pictogram
What happens when you double-click a cell containing a formula?
The cell gets deleted
The formula appears in the formula bar
The cell gets copied
The formula gets calculated
How do you adjust the width of a column?
Right-click and select "Column Width"
Double-click the column boundary
Press the spacebar
Use the zoom function
Which feature would you use to represent data using small repeating images?
Bar chart
Line graph
Pictogram
Scatter plot
What is the purpose of page setup in Excel?
To format cells
To create formulas
To adjust how the spreadsheet will print
To insert pictures
How can you quickly format multiple cells with the same settings?
Format painter
Copy and paste
Double-click each cell
What happens when you click the formula bar?
The spreadsheet prints
You can edit the contents of the active cell
The cell gets deleted
A new worksheet opens
