NEW
Font size
WorksheetsMicrosoft Excel 2010 Fundamentals
Total questions: 20
Worksheet time: 20mins
What is the first operator applied in Excel according to the order of precedence?
Multiplication
Parentheses
Addition
Division
How is an Excel function typically started?
By typing the function name.
By clicking the Insert Function button.
By typing an equal sign (=).
By selecting a range of cells.
What is the purpose of the AutoComplete feature in Excel?
It applies conditional formatting.
It automatically completes a typed function or value.
It fills cells with sequential data.
It checks spelling errors.
What is a relative cell reference?
A cell address that remains constant when copied.
A reference that adjusts relative to the formula location.
A reference with a fixed row and column.
A cell reference used only in formulas.
Which key is used to toggle between absolute, relative, and mixed references?
F2
F4
Ctrl
Alt
What does the ROUND function do?
Removes decimals completely.
Rounds a value to the nearest whole number.
Rounds a value to a specified number of decimal places.
Converts data into percentages.
What happens when you copy a formula with an absolute cell reference?
The formula remains unchanged.
The cell reference adjusts based on the new location.
Only the row changes, not the column.
The absolute reference remains fixed.
Which feature allows you to copy formulas to adjacent cells?
Paste Special
Fill Handle
AutoComplete
Format Painter
What does formatting a cell affect?
The data in the cell.
The appearance of the cell's content.
Both the data and appearance.
Only the alignment.
What is the default font size in Excel 2010?
10-point Calibri
11-point Arial
11-point Calibri
12-point Times New Roman
Which tool copies formatting from one cell to another?
AutoFormat
Format Painter
Fill Handle
Alignment Tool
How can you adjust a column's width?
By dragging the row header.
By right-clicking the column and selecting "Resize."
By dragging the edge of the column header.
By double-clicking the row header.
What is the purpose of conditional formatting?
To apply automatic formatting based on cell values.
To adjust column widths dynamically.
To change font styles in a worksheet.
To rename worksheets automatically.
What is a data bar in conditional formatting?
A visual representation of the range of values.
A horizontal bar that filters data.
A tool for adjusting font size.
A type of absolute reference.
What is the shortcut to open the Format Cells dialog box?
Ctrl + F
Ctrl + 1
Alt + Enter
Shift + F1
What happens when you merge and center cells?
The content is deleted.
The cells become one, and the text is centered.
Only the font size is adjusted.
Rows are automatically added.
What happens when you insert a row into a worksheet?
The contents of the worksheet shift to the right.
The contents below the row shift down.
The contents above the row shift up.
A new worksheet is created.
Which feature allows you to rename a worksheet?
Right-click the sheet tab and choose "Rename."
Double-click a cell and type the new name.
Click the Format Painter.
Use the Insert Function button.
Which tab contains the Font Color button?
Home
Insert
Page Layout
Review
How do you check spelling in an Excel worksheet?
Press Ctrl + S.
Click "Review" and select "Spelling."
Use the AutoFill feature.
Enable conditional formatting.
