Quizzes
Quizzes

Create a Quiz

My Favorites

My Watchlist

Search

Random Quiz

Browse Quizzes

All

Entertainment

Geography

History

Hobbies

Humanities

Literature

Movies

Music

Nature

Other

People

Religion

Science

Sports

Technology

Television

Daily Quiz

Microsoft Excel 101

How well do you know this spreadsheet program? Test your knowledge with this quiz!

Fun:

(1.85) Difficulty:

(2.34) Quiz ID: #50
Category: Technology > Computers Submitted By: brainster

Question #1

There is a tool in Excel that allows you to quickly fill up a column or a row with a series of numbers or alphabets, once you key in the first few. What is it called?

Your Answer: Show Hint

Question #2

If you have a sheet showing sales of each month in a column, and each product in a row, and you want to see this information in the opposite way (products in the column and months in the rows) how can you easily accomplish this?

Data -> Consolidate
Merge Cells
Data -> Sort
Data -> Pivot Table
None of the Above

Question #3

If you have first names in one column and last names in another column, which function can you use to easily put both together as the full name in a third column?

COMBINE()
ADD()
CONCATENATE()
MERGE()

Question #4

Is there any way you can ensure that the data entered into a column follows certain rules that you can set?

No, it is up to the user what they enter.
Yes, you can adjust the widths of the columns.
Yes, you can use the Validate option under the Data menu.
Yes, you can use the Strict option under the Data menu.
Yes, you can convert it to a DBF file.

Question #5

When you type in a formula in Excel and copy this formula across the entire column or row, the formula automatically changes to refer to the next column or row. What is this called?

Reference Shift
Relative Referencing
Referential Integrity
None of the above

Question #6

If you do not want Excel to change cell references automatically, but keep the cell fixed in a formula, what do you do?

Enclose the cell reference in # signs.
Add $ before the cell reference.
Turn off relative referencing.
None of the above.

Question #7

If you have a repetitive set of tasks that you perform on an Excel worksheet, what is the fastest way to get it done?

Make a list and follow it step by step
Use Macros
Use Tools->Track Changes
None of the above

Question #8

When you write a formula in Excel, the references in the formula are limited to that worksheet only. True or false?

True
False

Question #9

We've all done copying and pasting text. What if you wanted to copy and paste a cell format? What is the name of the tool provided to do this?

Your Answer: Show Hint

Question #10

If you want to insert the current date and time into a cell, the function to do this is -

TODAY()
NOW()
DATE()
None of the above

Share this Quiz: Tweet Share on Facebook Copy Link

Microsoft Excel 101

Question #1

There is a tool in Excel that allows you to quickly fill up a column or a row with a series of numbers or alphabets, once you key in the first few. What is it called?

Question #2

If you have a sheet showing sales of each month in a column, and each product in a row, and you want to see this information in the opposite way (products in the column and months in the rows) how can you easily accomplish this?

Question #3

If you have first names in one column and last names in another column, which function can you use to easily put both together as the full name in a third column?

Question #4

Is there any way you can ensure that the data entered into a column follows certain rules that you can set?

Question #5

When you type in a formula in Excel and copy this formula across the entire column or row, the formula automatically changes to refer to the next column or row. What is this called?

Question #6

If you do not want Excel to change cell references automatically, but keep the cell fixed in a formula, what do you do?

Question #7

If you have a repetitive set of tasks that you perform on an Excel worksheet, what is the fastest way to get it done?

Question #8

When you write a formula in Excel, the references in the formula are limited to that worksheet only. True or false?

Question #9

We've all done copying and pasting text. What if you wanted to copy and paste a cell format? What is the name of the tool provided to do this?

Question #10

If you want to insert the current date and time into a cell, the function to do this is -

Online Now

Get Your Free Braingle Account

Quizzes Quizzes Create a Quiz My Favorites My Watchlist Search Random Quiz Browse Quizzes All Entertainment Geography History Hobbies Humanities Literature Movies Music Nature Other People Religion Science Sports Technology Television Daily Quiz

Microsoft Excel 101

Question #1

There is a tool in Excel that allows you to quickly fill up a column or a row with a series of numbers or alphabets, once you key in the first few. What is it called?

Question #2

If you have a sheet showing sales of each month in a column, and each product in a row, and you want to see this information in the opposite way (products in the column and months in the rows) how can you easily accomplish this?

Question #3

If you have first names in one column and last names in another column, which function can you use to easily put both together as the full name in a third column?

Question #4

Is there any way you can ensure that the data entered into a column follows certain rules that you can set?

Question #5

When you type in a formula in Excel and copy this formula across the entire column or row, the formula automatically changes to refer to the next column or row. What is this called?

Question #6

If you do not want Excel to change cell references automatically, but keep the cell fixed in a formula, what do you do?

Question #7

If you have a repetitive set of tasks that you perform on an Excel worksheet, what is the fastest way to get it done?

Question #8

When you write a formula in Excel, the references in the formula are limited to that worksheet only. True or false?

Question #9

We've all done copying and pasting text. What if you wanted to copy and paste a cell format? What is the name of the tool provided to do this?

Question #10

If you want to insert the current date and time into a cell, the function to do this is -

Online Now

Follow Braingle!

Get Your Free Braingle Account

Quizzes
Quizzes

Create a Quiz

My Favorites

My Watchlist

Search

Random Quiz

Browse Quizzes

All

Entertainment

Geography

History

Hobbies

Humanities

Literature

Movies

Music

Nature

Other

People

Religion

Science

Sports

Technology

Television

Daily Quiz