Question 1

You can auto fit the width of column by
A) double clicking on the column name on column header
B) double click on the cell pointer in worksheet
C) double clicking on column right border on column header
D) double clicking on the column left border of column header

Accepted Answer

Double clicking on the right border of a column header in a spreadsheet program like Microsoft Excel or Google Sheets will automatically adjust the column's width to fit the content. This is a quick way to ensure that all data in a column is visible without manually adjusting the column width.

Question 2

Long text can be broken down into many lines within a cell. You can do this through
A) wrap text in format >> cells
B) justify in edit >> cells
C) text wrapping in format >> cells, layout tab
D) all of above

Accepted Answer

A

Question 3

MS Excel provides the default value for step in Fill Series dialog box
A) 0
B) 1
C) 5
D) 10

Accepted Answer

The default step value in the Fill Series dialog box of MS Excel is 1, which is used when creating a series of numbers.

Question 4

Ctrl + D shortcut key in Excel will
A) open the font dialog box
B) apply double underline for the active cell
C) fill down in the selection
D) none of above

Accepted Answer

The Ctrl + D shortcut in Excel is used to fill down or copy the content and format of the topmost cell of a selected range into the cells below.

Question 5

The short cut key Ctrl + R is used in Excel to
A) right align the content of cell
B) remove the cell contents of selected cells
C) fill the selection with active cells to the right
D) none of above

Accepted Answer

Ctrl + R in Excel is used to fill the selection with the contents of the active cell to the right. This is a quick way to copy data or formulas to adjacent cells in the same row.

Question 6

The command Edit >> Fill Across Worksheet is active only when
A) one sheet is selected
B) when many sheets are selected
C) when no sheet is selected
D) none of above

Accepted Answer

The command Edit >> Fill Across Worksheet is active only when multiple sheets are selected. This allows you to fill data across similar cells in all selected sheets simultaneously.

Question 7

Which of the following series type is not valid for Fill Series dialog box?
A) linear
B) growth
C) auto fill
D) time

Accepted Answer

The answer of Which of the following series type is...

Question 8

Which of the following you can paste selectively using Paste Special command?
A) validation
B) formats
C) formulas
D) all of above

Accepted Answer

The Paste Special command allows you to paste specific elements of copied data such as validation rules, formats, and formulas, among other options. This means you can choose to paste only the elements you need from the copied data, making it a versatile tool for managing how information is transferred between cells or documents.

Question 9

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A) square
B) percentage
C) goal seek
D) divide

Accepted Answer

The "Paste Special" feature in spreadsheet applications like Excel allows operations such as addition, subtraction, multiplication, and division when pasting data.

Question 10

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

Accepted Answer

The Delete command deletes selected cells.

Question 11

To remove the content of selected cells you must issue ______ command
A) edit >> delete
B) edit >> clear >> contents
C) edit >> clear >> all
D) data >> delete

Accepted Answer

The correct command to remove the content of selected cells without deleting the cells themselves is "Edit >> Clear >> Contents." This action clears the data in the cells but leaves the cells and their formatting intact.

Question 12

The Delete key of keyboard is assigned to which command in Excel?
A) edit >> clear >> contents
B) edit >> clear >> all
C) edit >> delete
D) all of above

Accepted Answer

The answer of The Delete key of keyboard is assigned...

Question 13

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
A) from edit menu choose clear and then formats
B) from edit menu choose delete
C) click on remove formatting tool on standard toolbar
D) double click the format painter and then press esc key in keyboard

Accepted Answer

Option A is correct because choosing "clear" and then "formats" from the edit menu specifically removes only the formatting in a range without affecting the content like numbers and formulas.

Question 14

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A) right click on sheet tab of third sheet and choose delete from the context menu
B) click on sheet 3 and from edit menu choose delete
C) both of above
D) none of above

Accepted Answer

To delete a worksheet in Excel, you can right-click on the sheet tab of the worksheet you want to delete and choose "Delete" from the context menu. Option B is incorrect because Excel does not have a specific "Delete" option under the "Edit" menu for deleting sheets.

Question 15

Which of the following action removes a sheet from workbook?
A) select the sheet, then choose edit >> delete sheet
B) select the sheet then choose format >> sheet >> hide
C) both of above
D) none of above

Accepted Answer

Selecting the sheet and then choosing Edit >> Delete Sheet is the correct action to remove a sheet from a workbook. Option B, which involves hiding the sheet, does not remove it but merely makes it invisible.

Question 16

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

Accepted Answer

Excel allows users to find and replace data within a specific sheet or across the entire workbook. Additionally, Excel does have the option to match case during the find and replace process, making statement B incorrect.

Question 17

Which of the following is not true about Find and Replace in Excel
A) you can search for bold and replace with italics
B) you can decide whether to look for the whole word or not
C) you can search in formula too
D) you can search by rows or columns or sheets

Accepted Answer

Find and Replace in Excel allows you to search by rows or columns, but not across multiple sheets simultaneously.

Question 18

You can move a sheet from one workbook into new book by
A) from edit menu choose move or copy sheet, mark the create a copy and click ok
B) from edit menu choose move of copy then choose (move to end) and click ok
C) from edit menu choose move or copy then select (new book) from to book list and click ok
D) none of above

Accepted Answer

Option C is correct because it directly describes the process of moving a sheet from one workbook to a new workbook by using the "Move or Copy" feature found in the Edit menu, and then selecting "New Book" from the "To book" list before clicking OK.

Question 19

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

Accepted Answer

Ctrl + H is the shortcut key used to open the Find and Replace dialog box in spreadsheet programs like Microsoft Excel, allowing users to replace data with another.

Question 20

To start Microsoft PowerPoint application
A) click on start >> programs >> all programs >> microsoft powerpoint
B) hit ctrl + r then type ppoint. exe and enter
C) click start >> run then type power point then press enter
D) all of above

Accepted Answer

All the options provided are methods to start Microsoft PowerPoint, although some methods might be more conventional or updated than others. Option A describes navigating through the Start menu, which is a common way to open applications. Option B uses the Run command with a specific executable name (though the correct executable name is 'powerpnt.exe', not 'ppoint.exe', but the intent is clear). Option C also uses the Run command but with a less precise command; typically, you would need to type the exact executable name or have a shortcut named exactly "power point" for this to work. However, the essence of all options is to demonstrate different ways to launch PowerPoint, making D the most inclusive choice despite the slight inaccuracies in command specifics.

Quiz 5: Excel and Powerpoint Functions and Shortcuts

You can auto fit the width of column by

Long text can be broken down into many lines within a cell. You can do this through

MS Excel provides the default value for step in Fill Series dialog box

Ctrl + D shortcut key in Excel will

The short cut key Ctrl + R is used in Excel to

The command Edit >> Fill Across Worksheet is active only when

Which of the following series type is not valid for Fill Series dialog box?

Which of the following you can paste selectively using Paste Special command?

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Edit >> Delete command

To remove the content of selected cells you must issue ______ command

The Delete key of keyboard is assigned to which command in Excel?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed) , you must

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

Which of the following action removes a sheet from workbook?

While finding and replacing some data in Excel, which of the following statement is valid?

Which of the following is not true about Find and Replace in Excel

You can move a sheet from one workbook into new book by

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

To start Microsoft PowerPoint application