when working with predefined formulas in excel,what category contains the boolean functions?
(a)math and trig
(b)recently used
(c)logical
(d)auto sum
my answer is c
debbie needs to print her table.which of the following is not an excel print program?
(a)title
(b)table
(c)selection
(d)entire worksheet
my answer is a
which of the following keys on a keyboard allows you to select multiple cells located in different parts of your worksheet?
(a)tab
(b)ctrl
(c)alt
(d)shift
my answer is b
which of the following is an example of a complex formula?
(a)income-expenses
(b)sum(a1:a14)
(c)=a1<=a14
(d)=150*.05
my answer is c
which of the following is a group of cells chosen to perform an action?
(a)command
(b)data series
(c)range
(d)group
my answer is c
which of the following identifies the patterns used for each data series in a chart?
(a)data point
(b)data points
(c)the horizontal and vertical axes
(d)legend
my answer is c
reneee is customizing a chart for her monday morning management meeting .for renee to customize a chart,she must first select?
(a)a title
(b)the colors
(c)a chart
(d)the data
my answer is d
david has a small business and is working on an excel worksheet to help manage his inventory.david realizes cell e14 has the wrong output.to check the problem david should first select e14 and look at the ? to check the output?
(a)formula bar
(b)name box
(c)range
(d)function tab
my answer is c
can someone please check my answers.thanks so much
I'm not sure of the last two, but the others seem correct to me.
Great job on answering the questions! Let me verify your answers for you:
1. When working with predefined formulas in Excel, the category that contains the boolean functions is (c) logical. Correct!
2. The Excel print program that is not an option is (a) title. Correct!
3. The key on a keyboard that allows you to select multiple cells located in different parts of your worksheet is (b) ctrl. Correct!
4. An example of a complex formula is (c) =a1<=a14. Incorrect, the correct answer is (a) income-expenses.
5. A group of cells chosen to perform an action is called a (c) range. Correct!
6. The patterns used for each data series in a chart are identified by (d) legend. Incorrect, the correct answer is (b) data points.
7. To customize a chart, Renee must first select (c) a chart. Incorrect, the correct answer is (a) a title.
8. To check the problem in cell E14, David should first select E14 and look at the (a) formula bar. Incorrect, the correct answer is (b) name box.
Overall, you got 5 out of 8 answers correct. Keep up the good work!