Microsoft Excel Basics Quiz

Play an AI-generated podcast conversation about this lesson

What is the correct method to insert a picture in a Microsoft Excel worksheet?

Navigate to Page Layout Tab → Page Setup → Breaks
Navigate to Insert Tab → Illustrations → Pictures (correct)
Go to the Data Tab → Get Data → From Web
Use the Run Command and type 'insert picture'

Which tab do you need to visit to remove a page break in Excel?

Page Layout Tab → Breaks (correct)
Review Tab → Changes
Insert Tab → Symbols
Data Tab → Get Data

Which function would you use to find the total in a column within Excel?

Use the Insert Tab → Symbols → Equations
Use the Data Tab → Get Data
Use mathematical operations such as Addition or Subtraction (correct)
Use the Insert Tab → Illustrations

What is one way to start a new spreadsheet in Excel?

Use Windows Logo + R and enter 'excel' (B) Signup and view all the answers

To insert functions as formulas in Excel, which sequence is correct?

Insert Tab → Symbols → Equations (C) Signup and view all the answers

Which of the following methods can be used to insert a new column in MS Excel?

Right Click over the column identifier and tap on Insert (B), Navigate to Home Tab → Cells Section → Insert → Insert Sheet Column (D) Signup and view all the answers

How can you insert a new sheet in MS Excel?

Navigate to Home Tab → Cells Section → Insert → Insert Sheet (A), Tap on the (+) next to Sheet 1 at the bottom of the window (D) Signup and view all the answers

Which tab do you navigate to when adding Clipart in MS Excel?

Insert Tab (A) Signup and view all the answers

What is one of the methods to insert a new row in MS Excel?

Right Click over the left row identifier and tap on Insert (C) Signup and view all the answers

What functionality does MS Excel provide regarding data from external files?

You can copy paste or insert data from various external files like web content or documents. (A) Signup and view all the answers

What is the correct syntax for the SUMIF function in MS Excel?

SUMIF(range, criteria, sum_range) (B) Signup and view all the answers

What must be done to change the reference style from A1 to R1C1 in Excel?

Clear the R1C1 reference style box in the Formulas tab (C) Signup and view all the answers

What would happen if you format a cell as a date and input 36526?

The cell will display 1/1/2000 (C) Signup and view all the answers

What is the first step to open a new spreadsheet in MS Excel?

Use the Windows Logo + R command to run Excel (D) Signup and view all the answers

Which option is NOT a formatting category in Excel?

Function (C) Signup and view all the answers

What color should the total marks be shaded in according to the formatting instructions?

Blue (D) Signup and view all the answers

What does the General number format do in Excel cells?

Displays numbers exactly as they are entered (B) Signup and view all the answers

What is one of the aims of formatting in a spreadsheet?

To add visual appeal and clarity to the data (A) Signup and view all the answers

What does the COUNT function do in MS Excel?

Counts the number of cells that contain numbers (D) Signup and view all the answers

What is the correct syntax for the AVERAGE function in MS Excel?

=AVERAGE(number1,number2,...) (B) Signup and view all the answers

Which function would you use to find the largest number in a set of values?

MAX (C) Signup and view all the answers

In the syntax of COUNTIF, what does 'criteria' refer to?

The specific condition that must be met (D) Signup and view all the answers

How do you calculate the total sales for a specific month using SUMIF?

Using the syntax =SUMIF(month_range, criteria, sales_range) (B) Signup and view all the answers

What value is returned by the MIN function if applied to the values 10, 20, and 5?

5 (A) Signup and view all the answers

What happens when you press enter after typing in a formula in MS Excel?

The formula is evaluated and the result is displayed (C) Signup and view all the answers

What input does the MAX function require?

At least one numerical value (C) Signup and view all the answers

What is the first step to open a new PowerPoint Presentation?

Use Windows Logo + R then type 'powerpnt' (C) Signup and view all the answers

Where do you go to create a presentation based on a design template?

Click the File tab and then New in the Backstage view (B) Signup and view all the answers

What action should you take to create a presentation using a design template after previewing it?

Click the Create button in the preview window (A) Signup and view all the answers

What does clicking the Blank Presentation thumbnail do?

Starts a new presentation without any pre-set design (D) Signup and view all the answers

What command should be used to display the Backstage view?

Click the File tab (C) Signup and view all the answers

Which of the following options is NOT a valid method to open a new PowerPoint Presentation?

Using a web browser to open PowerPoint Online (B) Signup and view all the answers

What must you do to view alternative color schemes and graphic backgrounds for a presentation design template?

Open the preview window after selecting a thumbnail (A) Signup and view all the answers

What is the final result of following the procedure outlined for creating a presentation in PowerPoint?

A new presentation with selected slides and styles will be created (C) Signup and view all the answers

Which menu path allows you to print presentations as handouts?

File → Print → Settings → Handouts (D) Signup and view all the answers

What happens to a hyperlink when the object it is attached to is deleted?

The hyperlink is deleted as well (A) Signup and view all the answers

What file type is created for a standalone presentation viewer in PowerPoint?

.ppsx (D) Signup and view all the answers

Which of the following is NOT an option for accessing the Insert Hyperlink box?

Select the object, then press Alt+H (A) Signup and view all the answers

When generating handouts, how many slides can you choose to display per page?

Any number of your choice (D) Signup and view all the answers

Which steps are necessary to edit a hyperlink attached to an object?

Select the object and right-click to choose Edit Hyperlink (A) Signup and view all the answers

To create a new PowerPoint presentation, which of the following steps is NOT required?

Choose a template (A) Signup and view all the answers

Opening MS Excel

Methods to launch Microsoft Excel spreadsheet application on Windows.

Inserting Rows in Excel

Three ways to add new rows in a spreadsheet: using the Home tab, Right-clicking row identifiers, and Right-clicking a cell.

Adding Columns to Excel

Methods for inserting new columns: the Home tab, right-clicking column identifiers, and right-clicking a cell.

Inserting Sheets in Excel

Two ways to add new sheets: through the Home tab and using a button at the bottom of the Excel window.