Basic of IT-MS Office Quiz

Which tab in Microsoft Word contains the "Bold" option?

• Home

• Insert

• Design

• View

What is the default font style in Microsoft Word?

• Times New Roman

• Arial

• Calibri

• Verdana

Which shortcut is used to open a new document in Word?

• Ctrl + N

• Ctrl + O

• Ctrl + S

• Ctrl + P

Which view in Word shows the document as it would appear when printed?

• Draft view

• Print Layout view

• Web Layout view

• Outline view

In Microsoft Word, how can you add a table to a document?

• Insert > Table

• Design > Table

• Layout > Table

• View > Table

Which option in Word is used to change the alignment of text?

• Text Direction

• Align Text

• Word Wrap

• Page Setup

Which function is used to calculate the sum of a range of numbers in Excel?

• AVERAGE

• SUM

• COUNT

• IF

Which of the following is a valid Excel formula for finding the average of cells A1 through A5?

• =AVERAGE(A1:A5)

• =SUM(A1:A5)

• =COUNT(A1:A5)

• =AVG(A1:A5)

Which Excel function returns the largest value in a range of cells?

• MAX

• MIN

• COUNT

• SUM

What does the "$" symbol do in a cell reference (e.g., $A$1) in Excel?

• It makes the reference absolute

• It makes the reference relative

• It changes the reference to text

• It locks the column only