Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel Basics - Year 7

Total questions: 75

Worksheet time: 41mins

Name
Class
Date
1.

How can you create a chart in Microsoft Excel?

a)

Select data, go to Insert tab, choose chart type, customize

b)

Click on the File tab

c)

Type the data manually

d)

Use the Paint tool

2.

What is the function of formulas in Microsoft Excel?

a)

To play music

b)

To send emails

c)

To create animations

d)

The function of formulas in Microsoft Excel is to perform calculations, manipulate data, and automate tasks.

3.

Explain the process of sorting data in Microsoft Excel.

a)

Select range -> Format tab -> Sort button -> Choose column -> Select order -> OK

b)

Click on cell -> Home tab -> Sort button -> Choose column -> Select order -> OK

c)

Highlight data -> Insert tab -> Sort button -> Choose column -> Select order -> OK

d)

Select range -> Data tab -> Sort button -> Choose column -> Select order -> OK

4.

How can you format cells in Microsoft Excel?

a)

Press Ctrl + F -> Type in formatting commands -> Press Enter

b)

Select cells -> Go to 'Home' tab -> Choose formatting options

c)

Right-click on cells -> Select 'Format' -> Choose formatting options

d)

Open 'Insert' tab -> Click on 'Format Cells' -> Apply desired formatting

5.

Where can you find the Excel Interface?

a)

Microsoft Word application

b)

Google Sheets

c)

Microsoft Excel application

d)

Adobe Photoshop

6.

What is the purpose of filtering data in Excel?

a)

To make the data harder to read

b)

The purpose of filtering data in Excel is to focus on specific information, hide unnecessary data, and analyze data more effectively.

c)

To slow down the analysis process

d)

To increase the file size

7.

How do you apply conditional formatting in Excel?

a)

Right-click on cells, select Conditional Formatting, choose rule, set conditions, click OK.

b)

Select range of cells, go to Home tab, click Conditional Formatting, choose rule, set conditions, click OK.

c)

Select range of cells, go to Data tab, click Conditional Formatting, choose rule, set conditions, click OK.

d)

Go to Insert tab, click Conditional Formatting, choose rule, set conditions, click OK.

8.

What are the steps to create a bar chart in Excel?

a)

Select data, go to Data tab, click on Line Chart, choose chart type

b)

Highlight data, go to Home tab, click on Insert Chart, select Bar Chart

c)

Select data, go to Insert tab, click on Bar Chart, choose chart type

d)

Copy data, paste into Word document, insert a picture of a bar chart

9.

What is the difference between SUM and AVERAGE functions in Excel?

a)

The SUM function multiplies numbers, while the AVERAGE function divides them.

b)

The SUM function calculates the average, while the AVERAGE function adds numbers.

c)

The SUM function adds numbers, while the AVERAGE function calculates the average.

d)

Both SUM and AVERAGE functions calculate the average.

10.

How can you sort data alphabetically in Excel?

a)

Select the range of data, go to 'Data' tab, click on 'Sort A to Z' or 'Sort Z to A' button.

b)

Manually rearrange the data by dragging and dropping

c)

Use the 'Filter' option to sort alphabetically

d)

Click on the 'Format' tab and select 'Sort A to Z'

11.

Explain the importance of cell formatting in Excel.

a)

Cell formatting in Excel is crucial for visually enhancing data presentation, highlighting key information, and improving overall readability and organization of the spreadsheet.

b)

Cell formatting in Excel is a time-consuming process with no benefits

c)

Cell formatting in Excel has no impact on data analysis

d)

Cell formatting in Excel is only used for aesthetic purposes

12.

Where is the 'Filter' option located in Excel?

a)

Insert tab

b)

Home tab

c)

Review tab

d)

Data tab

13.

What is the significance of conditional formatting in Excel?

a)

It helps in emphasizing key insights and trends within the data.

b)

It allows you to insert images into cells

c)

It changes the font style of the entire spreadsheet

d)

It automatically calculates formulas in Excel

14.

How do you change the color of a cell in Excel?

a)

Insert tab -> Color -> Apply to cell

b)

Right-click cell -> Change color

c)

Select cell(s) -> Home tab -> Font Color -> Choose color

d)

Format tab -> Cell Color -> Pick color

15.

What are the different types of charts available in Excel?

a)

Waterfall

b)

Polar

c)

Gantt

d)

Heatmap

e)

Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Doughnut, Bubble, Radar, Combo

16.

How can you use the IF function in Excel?

a)

Start a formula with =IF(logical_test, value_if_true, value_if_false)

b)

Use the IF function as a text formatting tool

c)

IF function can only be used for basic arithmetic operations

d)

IF function is not compatible with Excel

17.

What is the purpose of freeze panes in Excel?

a)

To lock specific rows or columns in place while scrolling through a large dataset.

b)

To change the font color of specific cells

c)

To calculate formulas automatically

d)

To create pivot tables

18.

Explain the process of creating a line chart in Excel.

a)

Use the Data Analysis tool

b)

Select the Pie Chart option

c)

Select data, go to Insert tab, click Line Chart, choose chart type

d)

Click on the Format tab

19.

How do you hide specific rows in Excel?

a)

Select rows -> Right-click -> Hide

b)

Highlight -> Delete

c)

Merge -> Sort

d)

Filter -> Unhide

20.

What is the benefit of using pivot tables in Excel?

a)

Summarizing and analyzing large datasets

b)

Creating animations

c)

Baking cookies

d)

Solving Sudoku puzzles

21.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

22.

A four-sided arrow does what in Excel?

a)

copies the contents of one cell to others around it

b)

moves the contents of one cell to another location

c)

selects the cell

23.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

24.

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

a)

cell bar

b)

formula bar

c)

status bar

d)

name box

25.

If you click a number at the left of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

26.

Where are the two places to find the autosum feature?

a)

Home ribbon

b)

Insert ribbon

c)

Function ribbon

d)

Formulas ribbon

27.

To exit an active formula, you always click out of the current cell?

a)

True

b)

False

28.

If the following was entered into a cell, what would appear in that cell? sum(A1:B3)

a)

the sum of A1 through B3

b)

sum(A1:B3)

c)

nothing

29.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

30.

If you change the value in a cell then the associated graph will NOT change.

a)

True

b)

False

31.

Select all of the following that are available under the Autosum button:

a)

sum

b)

minimum

c)

average

d)

maximum

e)

division

32.

If you center or merge and center it does exactly the same thing.

a)

True

b)

False

33.

What tool allows you to capture the formatting in one location and easily format other cells the same way?

a)

copy and paste

b)

cut and paste

c)

format painter

d)

alignment tool

34.

What is the difference in the following numbers: 1/3, .33, 33%

a)

the value

b)

the format

c)

the function

35.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

36.

A four-sided arrow does what in Excel?

a)

copies the contents of one cell to others around it

b)

moves the contents of one cell to another location

c)

selects the cell

37.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

38.

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

a)

cell bar

b)

formula bar

c)

status bar

d)

name box

39.

If you click a number at the left of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

40.

Where are the two places to find the autosum feature?

a)

Home ribbon

b)

Insert ribbon

c)

Function ribbon

d)

Formulas ribbon

41.

To exit an active formula, you always click out of the current cell?

a)

True

b)

False

42.

If the following was entered into a cell, what would appear in that cell? sum(A1:B3)

a)

the sum of A1 through B3

b)

sum(A1:B3)

c)

nothing

43.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

44.

If you change the value in a cell then the associated graph will NOT change.

a)

True

b)

False

45.

Select all of the following that are available under the Autosum button:

a)

sum

b)

minimum

c)

average

d)

maximum

e)

division

46.

What are the two (2) ways to display a spreadsheet in Microsoft Excel?

a)

fixed

b)

value

c)

variable

d)

formula

47.

If you center or merge and center it does exactly the same thing.

a)

True

b)

False

48.

What tool allows you to capture the formatting in one location and easily format other cells the same way?

a)

copy and paste

b)

cut and paste

c)

format painter

d)

alignment tool

49.

What is the difference in the following numbers: 1/3, .33, 33%

a)

the value

b)

the format

c)

the function

50.

What happens to a spreadsheet when you use the Ctrl~ command on a PC?

a)

calculates the values in formulas

b)

autofits the columns and rows

c)

displays the formulas

d)

nothing

51.

Which page orientation makes the sides longer than the top and bottom?

a)

landscape

b)

portrait

c)

fixed

d)

variable

52.

Margins are the white space on the spreadsheet where nothing prints.

a)

True

b)

False

53.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

54.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping

55.

Which page orientation makes the sides longer than the top and bottom?

a)

landscape

b)

portrait

c)

fixed

d)

variable

56.

The main file that contains one or more worksheets where you can enter data is called:

a)

Range

b)

Cell

c)

Worksheet

d)

Workbook

57.

A rectangular box in a worksheet where you can enter data, formulas, and function is called:

a)

Cell

b)

Workbook

c)

Range

d)

Worksheet

58.

A single spreadsheet within a workbook that consists of rows, columns, and cells are called:

a)

Range

b)

Worksheet

c)

Cell

d)

Workbook

59.

A group of adjacent cells, which can be selected and formatted together is called:

a)

Worksheet

b)

Workbook

c)

Cell

d)

Range

60.

A visual representation of data in a worksheet that can help you identify patterns and trends is called:

a)

Ribbon

b)

Chart

c)

Quick Access Toolbar

d)

Name box

61.

The box located to left of formula bar, which displays the reference of the selected cell or range is called:

a)

Ribbon

b)

Quick Access Toolbar

c)

Chart

d)

Name Box

62.

A customizable toolbar that provides quick access to frequently used commands is called:

a)

Name box

b)

Ribbon

c)

Quick Access Toolbar

d)

Chart

63.

Pre-designed spreadsheets that you can use to quickly create different types of documents:

a)

Resume

b)

Templates

c)

Cover Letter

d)

Spreadsheet

64.
3) Which of the following functions are you likely to find under the Insert tab on the Ribbon?
 
 
 
a)
a) Insert a page break. 
b)
 b) Insert a formula. 
c)
c) Insert a table. 
d)
d) Insert track changes. 
65.
4) Study the orange circled area of the worksheet in the image below.  Which of the following best describes the function of this area?
 
 
   
 
a)
a) The Name Box displays a name given to a cell or set of cells. 
b)
b) The Name Box reflects the contents of the first cell that is selected in a range. 
c)
c) The Name Box gives you options for duplicating the selected cells.
d)
d) All of the above options are correct. 
66.
6) What happens when you press the icon circled in orange in the image below?   
 
 
   

a)
a) It moves the worksheet up and hides rows. 
b)
b) It minimizes the Ribbon. 
c)
c) It opens another part of the Ribbon. 
d)
d) It detaches the Ribbon from the worksheet and allow you to move it around.
67.
7) Study the image below this question.  What is the purpose of the two words circled in orange? 
 
 
 
 

a)
a) These represent the names of the individual workbooks you have saved.  If you click on the "Sales 2" tab it will open this workbook. 
b)
b) These reflect a selected range of cells in the worksheet.  If you click on "Sales 2" it will take you to the selected cell. 
c)
c) These represent worksheets that have been created in the workbook.  If you click on them they will take you to the different sheets. 
d)
d) This is the Name Box and represents named ranges in the worksheet.  If you click on "Sales 2", you can rename the range. 
68.
8) Study the section of a worksheet in the image below.  What is the cell address of the cell containing the word "Qtr3"?
 
 
 
   
a)
a) The cell address is D1 
b)
b) The cell address is E 5 
c)
c) The cell address is D 4 
d)
d) The cell address is D 5
69.
10) Study the image below this question.  The Quick Access Toolbar is appearing below the Ribbon (circled in orange).  How would you go about moving it back to its position above the Ribbon?   
 
 

a)
a) This is a default setting with some versions of Excel.  You need to reinstall Excel to fix this issue. 
b)
b) You can move the toolbar back up to its position by holding down the left mouse button and dragging it into position. 
c)
c) If you close the workbook and reopen it again, the toolbar will move back to its original position. 
d)
 d) If you right click on it and select "Show Quick Access Toolbar above the Ribbon" it will move back.
70.
11) Study the screenshot above. You will note Row 2 is selected.  What happens when you press Ctrl+Shift++(plus) with a row selected?  
 
   
 
a)
a) The SUM of the values in the row is calculated. 
b)
b) The contents of the row is copied. 
c)
c) A new row is inserted above the selected row.
d)
d) A new column is inserted to the right of the selected row.
71.
12) What is the keyboard shortcut to select a row of active cells?

   
 
 
a)
 a) Shift + Spacebar 
b)
b) Ctrl + Spacebar
c)
c) Shift + End 
d)
d) Ctrl + End 
72.
14) What happens when you select cells and press Ctrl+2?  
 
 

a)
a) Text in the selected cells are underlined. 
 
b)
b) Bold formatting is applied to the text in the selected cells. 
c)
c) Italic formatting is applied to the text in the selected cells. 
d)
d) A duplicate of the selected cells will be inserted directly below the selection.
73.
18) What is the shortcut key to save a workbook?  
 
 
 
a)
a) Ctrl+Enter 
b)
b) Ctrl+Shift+S 
c)
c) Alt+S 
d)
d) Ctrl+S
74.

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

a)

A. Insert

b)

B. Copy

c)

C. Undo

d)

D. Replace

75.

Comments put in a cell are called

a)

A. Smart tip

b)

B. Web tip

c)

C. Cell tip

d)

D. Soft tip

Similar Resources on Wayground

Pemantapan PSAT Informatika 7

75 questions

Pemantapan PSAT Informatika 7

quiz

Worksheet

•

7th Grade

Gr 7 - Chapter 1, 2, 3 and 4

80 questions

Gr 7 - Chapter 1, 2, 3 and 4

quiz

Worksheet

•

6th - 8th Grade

RB3-CH-4-8-9-10

70 questions

RB3-CH-4-8-9-10

quiz

Worksheet

•

6th - 8th Grade

Year 8 End of Autumn Term 1 Assessment

75 questions

Year 8 End of Autumn Term 1 Assessment

quiz

Worksheet

•

7th Grade

3º ESO - UDI 6 - SCRATCH - FJBM - LSFB

80 questions

3º ESO - UDI 6 - SCRATCH - FJBM - LSFB

quiz

Worksheet

•

7th - 9th Grade

Kuis Berantai Informatika - 2

80 questions

Kuis Berantai Informatika - 2

quiz

Worksheet

•

6th - 8th Grade

Computer Science Review

76 questions

Computer Science Review

quiz

Worksheet

•

7th - 8th Grade

Python Turtle Quiz

75 questions

Python Turtle Quiz

quiz

Worksheet

•

5th - 12th Grade