Ashley BIM Review Exam Questions & Answers.
Which set of steps will organize the data to only show foods with more than 100 calories and rank their sugar content from greatest to least?
a. sort sugar in descending order, and filter Calories by under 100 calories.
b. sort sugar in ascending o...
Ashley BIM Review Exam Questions &
Answers.
Which set of steps will organize the data to only show foods with more than 100 calories and rank their
sugar content from greatest to least?
a. sort sugar in descending order, and filter Calories by under 100 calories.
b. sort sugar in ascending order, and filter Calories by over 100 calories.
c. filter Calories by over 100 calories, and sort Sugar in descending order.
d. filter Calories by over 100 calories, and sort Sugar in ascending order. - CORRECT ANSWER c
Which tool could be used to display only rows containing presidents who served two terms?
a. filter
b. find and replace
c. sort ascending
d. go to - CORRECT ANSWER a
In order to average together values that match two different conditions in different ranges, an Excel user
should use the ____________ function. - CORRECT ANSWER SUMIFS
Eilen is working on a form in Access and clicks on the Design tab in the Form Design Tools section. Eilen
then clicks on the Controls button and clicks the Label icon. What is Eilen most likely doing to the form?
a. adding a title
b. adding an existing field
c. changing the anchoring setting
d. changing the font of a label - CORRECT ANSWER a
, A spreadsheet contains the maximum weight and maximum height for fifty dog breeds. The breeds are
located in rows, and the weights and heights are listed in columns. Emily needs to determine the
maximum weight of the dog breed in row 43. Which tool could she use to quickly navigate to the
information?
a. locate
b. sort
c. filter
d. replace - CORRECT ANSWER a
What function should Jordan use to find the average number of hits per game for player A_Clemente?
a. SUMIF(Hits, "A__Clemente",Player)
b. SUMIF(Player, "A__Clemente",Hits)
c. AVERAGEIF(Hits, "A__Clemente",Player)
d. AVERAGEIF(Player, "A__Clemente",Hits) - CORRECT ANSWER d
In a SUMIF conditional function, what should be the order of terms in the parentheses?
a. the range whose values should be included in the SUMIF if the condition is met, then the range
evaluated for a condition, and then the condition itself
b. the condition itself, then the range whose values should be included in the SUMIF if the condition is
met, and then the range evaluated for a condition
c. the range whose values should be included in the SUMIF if the condition is met, then the condition
itself, and then the range evaluated for the condition
d. the range evaluated for a condition, then the condition itself, and then the range whose values should
be included in the SUMIF if the condition is met. - CORRECT ANSWER c
Raul is setting up an EXCEl spreadsheet to track how many hours his employees work each day. For the
first worker, he has inserted the formula "=(I3-H3)" into cell J3.
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur Nursewendo. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €12,10. Vous n'êtes lié à rien après votre achat.
