A) Ctrl + C

B) Ctrl + A

C) Ctrl + Spacebar

D) Ctrl + Enter

A) Finds the maximum value in a range

B) Finds the average value in a range

C) Adds up all the numbers in a range

D) Finds the minimum value in a range

A) COUNT

B) AVERAGE

C) SUM

D) MAX

A) To confirm an entry or move to the next cell

B) To delete the contents of a cell

C) To undo the last action

D) To save the workbook

A) MIN

B) AVG

C) MAX

D) SUM

A) To assign a specific name to a range of cells for easier reference

B) To automatically update the range when new data is added

C) To prevent other users from editing the range

D) To apply conditional formatting to the range

A) Using the AVG function

B) Using the AVERAGE function

C) Using the TOTAL function

D) Using the MEAN function

A) Returns the largest value in a range of cells

B) Returns the smallest value in a range of cells

C) Adds up all the numbers in a range of cells

D) Finds the average value in a range of cells

A) To apply a consistent formatting style to cells

B) To visually highlight cells that meet certain criteria based on specified rules

C) To automatically calculate values based on specified criteria

D) To lock cells so that they cannot be edited

A) To lock the cell reference so that it doesn't change when copied to other cells

B) To make the formula case-sensitive

C) To make the formula ignore errors

D) To automatically adjust the cell reference when copied to other cells

A) A reference to a specific Excel file

B) A reference to a specific cell or range of cells

C) A reference to a specific worksheet

D) A reference to a specific formula

A) Using the "Format Cells" dialog box

B) Using the "Format Painter" tool

C) Using the "Conditional Formatting" feature

D) Using the "Insert" tab

A) Right-click and select "Insert" from the context menu

B) Press Ctrl + R

C) Click on the "Insert Row" button on the ribbon

D) Press Alt + I

A) Double-click on the sheet tab and type the new name

B) Right-click on the sheet tab, select "Rename," and type the new name

C) Go to the "Page Layout" tab and click on "Rename Sheet"

D) All of the above

A) Using the font size drop-down menu in the "Home" tab

B) Right-clicking on the cell and selecting "Font Size"

C) Using the font size option in the "Format Cells" dialog box

D) All of the above

A) Right-click and select "Merge Cells" from the context menu

B) Press Ctrl + M

C) Go to the "Home" tab and click on the "Merge & Center" button

D) All of the above

A) Drag and drop the picture file into Excel

B) Copy and paste the picture from another application

C) Go to the "Insert" tab and click on "Pictures"

D) All of the above

A) Using the alignment buttons in the "Home" tab

B) Right-clicking on the cell and selecting "Format Cells"

C) Using the alignment options in the "Format" menu

D) All of the above

A) Drag the column boundary to the desired width

B) Right-click on the column header and select "Resize Column"

C) Go to the "Home" tab and click on the "Column Width" button

D) All of the above