Excel Exam 2024- 2025

Exam Details

Total Questions: 50
Marks per Question: 2 marks
Total Marks: 100
Passing Marks: 50 marks (25 correct answers)
Duration: 30 minutes
Device Requirement: You must bring your own smartphone or laptop to take the exam

1 / 50

When you insert an Excel file into a Word document, the data are

a. Hyperlinked

b. Placed in a word table

c. Linked

d. Embedded

2 / 50

The Name box

a. Shows the location of the previously active cell

b. Appears t the left of the formula bar

c. Appears below the status bar

d. Appears below the menu bar

3 / 50

How are data organized in a spreadsheet?

a. Lines and spaces

b. Layers and planes

c. Rows and columns

d. Height and width

4 / 50

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

a. HTML

b. Pivot Table Field List

c. Pivot Table List

d. Pivot Table Report

5 / 50

How many recent files you can display on File menu at maximum?

A) 4

B) 6

C) 9

D) 12

6 / 50

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

A) work sheet

B) chart sheet

C) module sheet

D) data sheet

7 / 50

How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

a. On the file menu, point to print area, and then click set print area.

b. On the file menu, click print, and then click selection under print what

c. On the view menu, click custom views, then click add

d. All of above

8 / 50

Which of the following option is not available in Paste Special dialog box?

Add

Subtract

Divide

SQRT

9 / 50

Which of the following is a correct order of precedence in a formula calculation?

a. Multiplication and division, exponential positive and negative value

b. Multiplication and division, positive and negative values, addition and subtraction

c. Addition and subtraction, positive and negative values, exponentiation d. None of above

d. None of above

10 / 50

What is the short cut key to replace a data with another in sheet?

A) Ctrl + R

B) Ctrl + Shift + R

C) Ctrl + H

D) Ctrl + F

11 / 50

Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box click on Merge Cells check box

From Format Cells dialog box select the Centered alignment

From Format Cells dialog box choose Merge and Center check box

Click on Merge and Center tool on formatting toolbar

12 / 50

you can use the formula palette to

a. format cells containing numbers

b. create and edit formulas containing functions

c. entered assumptions data

d. copy a range of cells

13 / 50

You can edit existing Excel data by pressing the

a. F1 key

b. F2 key

c. F3 key

d. F4 key

14 / 50

What happens if you remove the check mark from Row & Column headers on Options dialog box?

A) This will remove row headings and column headings of your data

B) This will remove the column headings

C) This will remove row and column heading of chart

D) This will remove row and column heading of table

15 / 50

Weight refers to

a. The print density of characters

b. The height of the printed character

c. Upright or slanted shape

d. The design and appearance of characters

16 / 50

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

a. Go to File-Save As – Save As Type – Excel worksheet

b. Right click on the spreadsheet tab and select DELETE

c. Right click on the spreadsheet and select Insert – Entire Column

d. None of above

17 / 50

Which of the following is not What IF analysis tool in Excel?

A) Goal Seek

B) Scenarios

C) Macros

D) None of above

18 / 50

Excel is a good application for What IF analysis. Which of the following tool help you for this?

A) Formul Auditing

B) Research

C) Track Change

D) Goal Seek

19 / 50

Which function calculates your monthly mortage payment?

a. PMT (payments)

b. NPER (number of periods)

c. PV (present value)

d. All of above

20 / 50

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

a. Formula

b. Field

c. Data

d. Query

21 / 50

The minimum and maximum value you can set for Save AutoRecovery Info in Excel are

A) 1 and 120 minutes

B) 0 and 120 minutes

C) 2 and 60 minutes

D) 1 and 10 minutes

22 / 50

When a row of data is to be converted into columns

A) Copy the cells in row, select the same number of cells in row and paste

B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

C) Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK

D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.

23 / 50

While Finding and Replacing some data in Excel, which of the following statement is valid?

A) You can Find and Replace within the sheet or workbook

B) Excel does not have option to match case for find

C) Both are valid

D) None are valid

24 / 50

You can automatically adjust the size of text in a cell if they do not fit in width by

A) Double clicking on the right border of column header

B) From Format choose Columns and then Autofit Selection

C) From Format Cells dialog box mark Shrink to fit check box

D) All of above

25 / 50

Which of the cell pointer indicates that you can fill series?

A) Doctor’s symbol (Big Plus)

B) small thin plus icon

C) Mouse Pointer with anchor at the tip

D) None of above

26 / 50

. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

a. Point to speech on the tools menu, and then click show text to speech toolbar.

b. Click validation on the data menu

c. Point to speech on the tools menu, and then click speech recognition

d. All of above

27 / 50

Edit >> Delete command

A) Deletes the content of a cell

B) Deletes Formats of cell

C) Deletes the comment of cell

D) Deletes selected cells

28 / 50

Hyperlinks cannot be

a. Special shapes like stars and banners

b. Drawing objects like rectangles ovals

c. Pictures

d. All can be hyperlinks

29 / 50

You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.

a. Standard

b. Formatting

c. Drawing

d. Picture

30 / 50

Merge cells option can be applied from

A) Format Cells dialog box Alignment Tab

B) Formatting toolbar

C) Both of above

D) None of above

31 / 50

to activate the previous cell in a pre-selected range, press

a. the Alt key

b. the Tab key

c. the Enter key

d. none of above

32 / 50

By default the cell pointer moves down when you press Enter. From where can you change this setting?

A) Tools >> Options >> View tab

C) Tools >> Options >> Edit tab

B) Tools >> Options >> Calculation tab

D) Tools >> Options >> Transition tab

33 / 50

Gridlines

a. May be turned off for display but turned on for printing

b. May be turned on or off for printing c. The be turned off for display and printingd. a, b and c

c. The be turned off for display and printing

d. a, b and c

34 / 50

when you print preview a worksheet

a. the entire worksheet is displayed

b. the selected range is displayed

c. the active portion of the worksheet is displayed

d. a, b and c

35 / 50

If you press …., the cell accepts your typing as its contents.

a. Enter

b. Ctrl + Enter

c. TAB

d. Insert

36 / 50

To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

a. Edit

b. Format

c. Tools

d. Data

37 / 50

Which of the following methods cannot be used to edit the content of cell?

a. Pressing the Alt key

b. Clicking the formula bar

c. Pressing F2

d. Double clicking the cell

38 / 50

How can you show or hide the gridlines in Excel Worksheet?

Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

Click Gridline tool on Forms toolbar

Both of above

None of above

39 / 50

Which of the following setup options can not be set in the page setup dialog box?

a. Printer selection

b. Vertical or horizontal placement

c. Orientation

d. Row and column titles

40 / 50

Which of the following is invalid statement?

A) Sheet tabs can be colored

B) Some picture can be applied as a background of a sheet

C) You can set the column width automatically fit the amount of text

D) The width of a row and be specified manually or fit automatically

41 / 50

Which of the following is not a worksheet design criterion?

a. Efficiency

b. Auditability

c. Description

d. Clarity

42 / 50

How can you remove borders applied in cells?

A) Choose None on Border tab of Format cells

B) Open the list on Border tool in Formatting toolbar then choose first tool (no border)

C) Both of above

D) None of above

43 / 50

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

A) F8

B) F9

C) F10

D) F11

44 / 50

Which of the following is not a basic step in creating a worksheet?

a. Save the workbook

b. Modify the worksheet

c. Enter text and data

d. Copy the worksheet

45 / 50

Each excel file is called a workbook because

a. It can contain text and data

b. It can be modified

c. It can contain many sheets including worksheets and chart sheets

d. You have to work hard to create it

46 / 50

What is entered by the function =today()

A) The date value for the day according to system clock

B) The time value according to system clock

C) Today’s date as Text format

D) All of above

47 / 50

Which of the following describes how to select all the cells in a single column?

a. Right click on column and select Pick from list

b. Use data – text to columns menu item

c. Left click on the gray column title button

d. Pressing Ctrl + A on the keyboard

48 / 50

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

A) Use =if() function to format the required numbers red

B) Apply Conditional Formatting command on Format menu

C) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

D) All of above

49 / 50

To center worksheet titles across a range of cell, you must

a. Select the cells containing the title text and use the fill handle to center the text across a range of cells

b. Widen the columns

c. Select the cells containing the title text and use the fill handle to center the text across a range of cells

d. Widen the column

50 / 50

what term describes a background that appears as a grainy, non smooth surface

a. gradient

b. pattern

c. solid

d. texture

Your score is

The average score is 46%