Excel Test 2024

What is the intersection point of a column and a row in Excel called?

• grid
• cell
• square
• block

Which term refers to the vertical arrangement of cells?

• stack
• column
• row
• tier

What do you call the process of changing the appearance of data in a cell?

• modifying
• transforming
• editing
• formatting

Which option allows you to apply a consistent appearance to selected cells?

• Color Picker
• Copy Paste
• Font Selector
• Format Painter

What is the name for the entire collection of rows and columns?

• spreadsheet
• grid
• table
• chart

Which feature in Excel allows you to automatically adjust the width of a column to fit the contents?

• Typing 'AutoFit' in the formula bar and pressing Enter
• Double-clicking the right edge of the column header
• Pressing Ctrl + A to select the entire sheet and then double-clicking the right edge of the column header
• Right-clicking the column header and selecting 'AutoFit Column Width'

What is the term for the action of combining multiple cells into one larger cell?

• Merge Rows
• Combine Cells
• Join Cells
• Merge Cells

Which function in Excel allows you to add up a range of numbers quickly?

• ADD
• SUMMATION
• SUM
• TOTAL

Which term refers to the action of moving data from one location to another within an Excel worksheet?

• 
  

• insert and delete
• drag and drop
• cut and paste
• copy and paste

What do you call a predefined set of formatting options in Excel?

• Formatting Styles
• Predefined Formats
• Excel Templates
• Cell Styles